All Questions
Tagged with geospatialdatabase-design
2 questions
2votes
1answer
4kviews
What is a good way to store geographical data for distance calculations
What would be the best way to store data in a database for geographical calculations? Say I have an ItemsForSale table paired to a Users table which holds their geo location. I know I can use latitude ...
0votes
2answers
479views
What are the benefits of using geospatial datatypes?
We currently store points as three floats (lat,lon,alt) and support only one type of query (points within a given radius) but look forward to support more queries. We are using PHP and MySQL. What ...